<?php

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

/**
 * Description of testSQL
 *
 * @author zhangxuelin
 */
class testSQL extends CI_Controller{
    //put your code here
    function index(){
        $this->dbConnectsql = $this->load->database("sqlserver_hr",TRUE);
        $query = $this->dbConnectsql->query("select * from A01 WHERE A0101 = '张忠良'");
        $resDate = $query->row_array();
        var_dump($resDate);
    }
}
